/****** Object:  StoredProcedure [dbo].[AddCOIUserHierarchyMap]    Script Date: 03/04/2009 12:53:11 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].UpdateWorkflowActivityStatus') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].UpdateWorkflowActivityStatus
GO
/******************************************************************            
* Name:				 UpdateWorkflowActivityStatus            
* Note:		            
* PARAMETERS(IN)            
* Name				 Description                 
* -------------      -------------------------------------------            
* @activityId        Id to update the activity status
*********************************************************************/            
            
CREATE PROCEDURE [dbo].UpdateWorkflowActivityStatus
(            
	@activityId int
)            
AS BEGIN            
SET NOCOUNT ON            
            
	update swactivityList 
	set Status = 'approved'
	where Id = @activityId

END    

